Creating a Spatial Table for a Read/Write Connection

If a spatial table is to be used with Bentley Map using a read/write connection, the primary key and sequence requirements need to be met.

The following is an example of a CREATE TABLE statement with a primary key followed by a CREATE SEQUENCE:

CREATE TABLE customers (
  customer_id NUMBER CONSTRAINT customers_pk PRIMARY KEY,
  last_name VARCHAR2(30),
  first_name VARCHAR2(30),
  street_address VARCHAR2(40),
  city VARCHAR2(30),
  state_province_code VARCHAR2(2),
  postal_code VARCHAR2(9),
  cust_geo_location SDO_GEOMETRY);

 CREATE SEQUENCE customers_seq
  START WITH 1001 INCREMENT BY 1;